MacrosSamplesSet column widthOn this pageSet column widthDescription Sets the width for the column B. (function(){ Api.GetActiveSheet().SetColumnWidth(1, 25);})(); Methods used: GetActiveSheet, SetColumnWidth Reference Microsoft VBA macro code Sub example() Columns("B").ColumnWidth = 25End Sub Result